Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 47738 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.5 MiB |
| Average record size in memory | 120.0 B |
Variable types
| Categorical | 2 |
|---|---|
| DateTime | 1 |
| Numeric | 12 |
iso_code has a high cardinality: 131 distinct values | High cardinality |
country_region has a high cardinality: 131 distinct values | High cardinality |
retail_and_recreation_percent_change_from_baseline has 619 (1.3%) zeros | Zeros |
grocery_and_pharmacy_percent_change_from_baseline has 1398 (2.9%) zeros | Zeros |
parks_percent_change_from_baseline has 530 (1.1%) zeros | Zeros |
workplaces_percent_change_from_baseline has 595 (1.2%) zeros | Zeros |
residential_percent_change_from_baseline has 1747 (3.7%) zeros | Zeros |
new_cases_per_million has 7580 (15.9%) zeros | Zeros |
new_cases has 7580 (15.9%) zeros | Zeros |
new_deaths has 19595 (41.0%) zeros | Zeros |
new_deaths_per_million has 19595 (41.0%) zeros | Zeros |
Reproduction
| Analysis started | 2021-03-09 14:34:45.731390 |
|---|---|
| Analysis finished | 2021-03-09 14:35:19.360318 |
| Duration | 33.63 seconds |
| Software version | pandas-profiling v2.12.0 |
| Download configuration | config.yaml |
| Distinct | 131 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 373.1 KiB |
| ARG | 382 |
|---|---|
| DEU | 382 |
| FJI | 382 |
| FRA | 382 |
| SGP | 382 |
| Other values (126) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 143214 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ARE |
|---|---|
| 2nd row | ARE |
| 3rd row | ARE |
| 4th row | ARE |
| 5th row | ARE |
| Value | Count | Frequency (%) |
| ARG | 382 | 0.8% |
| DEU | 382 | 0.8% |
| FJI | 382 | 0.8% |
| FRA | 382 | 0.8% |
| SGP | 382 | 0.8% |
| PHL | 382 | 0.8% |
| KOR | 382 | 0.8% |
| LKA | 382 | 0.8% |
| FIN | 382 | 0.8% |
| ESP | 382 | 0.8% |
| Other values (121) | 43918 |
| Value | Count | Frequency (%) |
| arg | 382 | 0.8% |
| aus | 382 | 0.8% |
| phl | 382 | 0.8% |
| fin | 382 | 0.8% |
| svn | 382 | 0.8% |
| npl | 382 | 0.8% |
| vnm | 382 | 0.8% |
| lka | 382 | 0.8% |
| che | 382 | 0.8% |
| can | 382 | 0.8% |
| Other values (121) | 43918 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 12401 | 8.7% |
| R | 11733 | 8.2% |
| N | 10626 | 7.4% |
| L | 8417 | 5.9% |
| M | 7972 | 5.6% |
| B | 7857 | 5.5% |
| E | 7650 | 5.3% |
| G | 7516 | 5.2% |
| T | 6915 | 4.8% |
| S | 6278 | 4.4% |
| Other values (16) | 55849 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 143214 |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 12401 | 8.7% |
| R | 11733 | 8.2% |
| N | 10626 | 7.4% |
| L | 8417 | 5.9% |
| M | 7972 | 5.6% |
| B | 7857 | 5.5% |
| E | 7650 | 5.3% |
| G | 7516 | 5.2% |
| T | 6915 | 4.8% |
| S | 6278 | 4.4% |
| Other values (16) | 55849 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 143214 |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 12401 | 8.7% |
| R | 11733 | 8.2% |
| N | 10626 | 7.4% |
| L | 8417 | 5.9% |
| M | 7972 | 5.6% |
| B | 7857 | 5.5% |
| E | 7650 | 5.3% |
| G | 7516 | 5.2% |
| T | 6915 | 4.8% |
| S | 6278 | 4.4% |
| Other values (16) | 55849 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 143214 |
Most frequent character per block
| Value | Count | Frequency (%) |
| A | 12401 | 8.7% |
| R | 11733 | 8.2% |
| N | 10626 | 7.4% |
| L | 8417 | 5.9% |
| M | 7972 | 5.6% |
| B | 7857 | 5.5% |
| E | 7650 | 5.3% |
| G | 7516 | 5.2% |
| T | 6915 | 4.8% |
| S | 6278 | 4.4% |
| Other values (16) | 55849 |
date
Date
| Distinct | 382 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 373.1 KiB |
| Minimum | 2020-02-15 00:00:00 |
|---|---|
| Maximum | 2021-03-02 00:00:00 |
| Distinct | 375 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -24.75201307 |
| Minimum | -100 |
|---|---|
| Maximum | 62 |
| Zeros | 619 |
| Zeros (%) | 1.3% |
| Negative | 41616 |
| Negative (%) | 87.2% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -71 |
| Q1 | -39 |
| median | -21 |
| Q3 | -8 |
| 95-th percentile | 8 |
| Maximum | 62 |
| Range | 162 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 24.03599259 |
|---|---|
| Coefficient of variation (CV) | -0.9710722323 |
| Kurtosis | 0.202705403 |
| Mean | -24.75201307 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | -0.4510691642 |
| Sum | -1181611.6 |
| Variance | 577.7289396 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| -20 | 1013 | 2.1% |
| -22 | 971 | 2.0% |
| -18 | 963 | 2.0% |
| -21 | 913 | 1.9% |
| -19 | 912 | 1.9% |
| -15 | 909 | 1.9% |
| -12 | 886 | 1.9% |
| -17 | 885 | 1.9% |
| -10 | 885 | 1.9% |
| -14 | 881 | 1.8% |
| Other values (365) | 38520 |
| Value | Count | Frequency (%) |
| -100 | 2 | < 0.1% |
| -97 | 11 | < 0.1% |
| -96 | 22 | |
| -95 | 31 | |
| -94 | 22 |
| Value | Count | Frequency (%) |
| 62 | 2 | |
| 60 | 1 | < 0.1% |
| 59 | 1 | < 0.1% |
| 58 | 2 | |
| 57 | 3 |
| Distinct | 401 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -6.202832125 |
| Minimum | -100 |
|---|---|
| Maximum | 162 |
| Zeros | 1398 |
| Zeros (%) | 2.9% |
| Negative | 29565 |
| Negative (%) | 61.9% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -45 |
| Q1 | -16 |
| median | -5 |
| Q3 | 4 |
| 95-th percentile | 28 |
| Maximum | 162 |
| Range | 262 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 22.19363466 |
|---|---|
| Coefficient of variation (CV) | -3.577984091 |
| Kurtosis | 2.937448808 |
| Mean | -6.202832125 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | -0.3223534239 |
| Sum | -296110.8 |
| Variance | 492.5574196 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1398 | 2.9% |
| -2 | 1395 | 2.9% |
| -1 | 1381 | 2.9% |
| 1 | 1372 | 2.9% |
| -3 | 1356 | 2.8% |
| -4 | 1334 | 2.8% |
| -5 | 1296 | 2.7% |
| 2 | 1293 | 2.7% |
| -7 | 1222 | 2.6% |
| -6 | 1188 | 2.5% |
| Other values (391) | 34503 |
| Value | Count | Frequency (%) |
| -100 | 2 | < 0.1% |
| -98 | 2 | < 0.1% |
| -97 | 14 | |
| -96 | 10 | |
| -95 | 22 |
| Value | Count | Frequency (%) |
| 162 | 1 | |
| 160 | 1 | |
| 148 | 1 | |
| 127 | 1 | |
| 122 | 1 |
| Distinct | 685 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -2.915166115 |
| Minimum | -100 |
|---|---|
| Maximum | 517 |
| Zeros | 530 |
| Zeros (%) | 1.1% |
| Negative | 31335 |
| Negative (%) | 65.6% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -57 |
| Q1 | -28 |
| median | -12 |
| Q3 | 9 |
| 95-th percentile | 82 |
| Maximum | 517 |
| Range | 617 |
| Interquartile range (IQR) | 37 |
Descriptive statistics
| Standard deviation | 47.26114706 |
|---|---|
| Coefficient of variation (CV) | -16.2121626 |
| Kurtosis | 11.30416713 |
| Mean | -2.915166115 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 2.500724359 |
| Sum | -139164.2 |
| Variance | 2233.616021 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| -15 | 819 | 1.7% |
| -18 | 787 | 1.6% |
| -19 | 779 | 1.6% |
| -16 | 774 | 1.6% |
| -17 | 766 | 1.6% |
| -22 | 750 | 1.6% |
| -14 | 739 | 1.5% |
| -12 | 718 | 1.5% |
| -21 | 714 | 1.5% |
| -11 | 706 | 1.5% |
| Other values (675) | 40186 |
| Value | Count | Frequency (%) |
| -100 | 1 | < 0.1% |
| -95 | 3 | |
| -94 | 3 | |
| -93 | 3 | |
| -92 | 7 |
| Value | Count | Frequency (%) |
| 517 | 1 | |
| 484 | 1 | |
| 473 | 1 | |
| 455 | 1 | |
| 453 | 1 |
transit_stations_percent_change_from_baseline
Real number (ℝ)
| Distinct | 375 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -29.15483682 |
| Minimum | -100 |
|---|---|
| Maximum | 91 |
| Zeros | 413 |
| Zeros (%) | 0.9% |
| Negative | 42362 |
| Negative (%) | 88.7% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -100 |
|---|---|
| 5-th percentile | -70 |
| Q1 | -45 |
| median | -29 |
| Q3 | -13 |
| 95-th percentile | 9 |
| Maximum | 91 |
| Range | 191 |
| Interquartile range (IQR) | 32 |
Descriptive statistics
| Standard deviation | 23.9647793 |
|---|---|
| Coefficient of variation (CV) | -0.821982968 |
| Kurtosis | 0.07469423655 |
| Mean | -29.15483682 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 0.0226636942 |
| Sum | -1391793.6 |
| Variance | 574.3106468 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| -35 | 846 | 1.8% |
| -24 | 816 | 1.7% |
| -30 | 793 | 1.7% |
| -32 | 793 | 1.7% |
| -29 | 787 | 1.6% |
| -34 | 782 | 1.6% |
| -36 | 775 | 1.6% |
| -23 | 775 | 1.6% |
| -26 | 774 | 1.6% |
| -22 | 758 | 1.6% |
| Other values (365) | 39839 |
| Value | Count | Frequency (%) |
| -100 | 1 | < 0.1% |
| -99 | 2 | < 0.1% |
| -98 | 1 | < 0.1% |
| -96 | 5 | |
| -95 | 10 |
| Value | Count | Frequency (%) |
| 91 | 1 | < 0.1% |
| 84 | 1 | < 0.1% |
| 81 | 1 | < 0.1% |
| 79 | 1 | < 0.1% |
| 77 | 3 |
| Distinct | 193 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -22.85745109 |
| Minimum | -99 |
|---|---|
| Maximum | 80 |
| Zeros | 595 |
| Zeros (%) | 1.2% |
| Negative | 42605 |
| Negative (%) | 89.2% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -99 |
|---|---|
| 5-th percentile | -61 |
| Q1 | -33 |
| median | -21 |
| Q3 | -9 |
| 95-th percentile | 5 |
| Maximum | 80 |
| Range | 179 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 19.4574084 |
|---|---|
| Coefficient of variation (CV) | -0.8512501384 |
| Kurtosis | 0.5074004387 |
| Mean | -22.85745109 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -0.6042455305 |
| Sum | -1091169 |
| Variance | 378.5907417 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| -24 | 1115 | 2.3% |
| -20 | 1093 | 2.3% |
| -18 | 1089 | 2.3% |
| -26 | 1085 | 2.3% |
| -23 | 1064 | 2.2% |
| -12 | 1056 | 2.2% |
| -25 | 1051 | 2.2% |
| -16 | 1045 | 2.2% |
| -17 | 1040 | 2.2% |
| -21 | 1040 | 2.2% |
| Other values (183) | 37060 |
| Value | Count | Frequency (%) |
| -99 | 2 | < 0.1% |
| -94 | 1 | < 0.1% |
| -92 | 2 | < 0.1% |
| -91 | 3 | < 0.1% |
| -90 | 17 |
| Value | Count | Frequency (%) |
| 80 | 1 | |
| 74 | 1 | |
| 71 | 1 | |
| 67 | 2 | |
| 56 | 1 |
| Distinct | 194 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.613754242 |
| Minimum | -35 |
|---|---|
| Maximum | 55 |
| Zeros | 1747 |
| Zeros (%) | 3.7% |
| Negative | 4139 |
| Negative (%) | 8.7% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -35 |
|---|---|
| 5-th percentile | -2 |
| Q1 | 3 |
| median | 8 |
| Q3 | 14 |
| 95-th percentile | 27 |
| Maximum | 55 |
| Range | 90 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 8.844899105 |
|---|---|
| Coefficient of variation (CV) | 0.9200255053 |
| Kurtosis | 1.01201556 |
| Mean | 9.613754242 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.8403260319 |
| Sum | 458941.4 |
| Variance | 78.23224017 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 2352 | 4.9% |
| 5 | 2342 | 4.9% |
| 9 | 2329 | 4.9% |
| 4 | 2301 | 4.8% |
| 7 | 2255 | 4.7% |
| 6 | 2252 | 4.7% |
| 8 | 2250 | 4.7% |
| 3 | 2190 | 4.6% |
| 11 | 2189 | 4.6% |
| 2 | 2169 | 4.5% |
| Other values (184) | 25109 |
| Value | Count | Frequency (%) |
| -35 | 1 | |
| -33 | 1 | |
| -21 | 1 | |
| -16 | 2 | |
| -15 | 1 |
| Value | Count | Frequency (%) |
| 55 | 2 | |
| 54 | 1 | |
| 53 | 1 | |
| 52 | 1 | |
| 51 | 2 |
| Distinct | 131 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 373.1 KiB |
| Argentina | 382 |
|---|---|
| United States | 382 |
| Nepal | 382 |
| Egypt | 382 |
| Singapore | 382 |
| Other values (126) |
Length
| Max length | 22 |
|---|---|
| Median length | 7 |
| Mean length | 8.126817211 |
| Min length | 4 |
Characters and Unicode
| Total characters | 387958 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United Arab Emirates |
|---|---|
| 2nd row | United Arab Emirates |
| 3rd row | United Arab Emirates |
| 4th row | United Arab Emirates |
| 5th row | United Arab Emirates |
| Value | Count | Frequency (%) |
| Argentina | 382 | 0.8% |
| United States | 382 | 0.8% |
| Nepal | 382 | 0.8% |
| Egypt | 382 | 0.8% |
| Singapore | 382 | 0.8% |
| Australia | 382 | 0.8% |
| Malta | 382 | 0.8% |
| Morocco | 382 | 0.8% |
| South Africa | 382 | 0.8% |
| Italy | 382 | 0.8% |
| Other values (121) | 43918 |
| Value | Count | Frequency (%) |
| united | 1146 | 2.0% |
| and | 1066 | 1.9% |
| south | 764 | 1.3% |
| new | 714 | 1.2% |
| egypt | 382 | 0.7% |
| spain | 382 | 0.7% |
| finland | 382 | 0.7% |
| fiji | 382 | 0.7% |
| australia | 382 | 0.7% |
| sweden | 382 | 0.7% |
| Other values (141) | 51189 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 64202 | |
| i | 33422 | 8.6% |
| n | 29472 | 7.6% |
| e | 26915 | 6.9% |
| r | 20808 | 5.4% |
| o | 19334 | 5.0% |
| t | 14311 | 3.7% |
| u | 13331 | 3.4% |
| l | 13263 | 3.4% |
| d | 12818 | 3.3% |
| Other values (46) | 140082 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 320745 | |
| Uppercase Letter | 56423 | 14.5% |
| Space Separator | 9433 | 2.4% |
| Other Punctuation | 357 | 0.1% |
| Open Punctuation | 341 | 0.1% |
| Close Punctuation | 341 | 0.1% |
| Dash Punctuation | 318 | 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 64202 | |
| i | 33422 | |
| n | 29472 | |
| e | 26915 | 8.4% |
| r | 20808 | 6.5% |
| o | 19334 | 6.0% |
| t | 14311 | 4.5% |
| u | 13331 | 4.2% |
| l | 13263 | 4.1% |
| d | 12818 | 4.0% |
| Other values (17) | 72869 |
| Value | Count | Frequency (%) |
| B | 6044 | 10.7% |
| S | 5210 | 9.2% |
| M | 3997 | 7.1% |
| C | 3667 | 6.5% |
| N | 3633 | 6.4% |
| A | 3291 | 5.8% |
| T | 3204 | 5.7% |
| L | 2917 | 5.2% |
| P | 2914 | 5.2% |
| G | 2832 | 5.0% |
| Other values (14) | 18714 |
| Value | Count | Frequency (%) |
| 9433 |
| Value | Count | Frequency (%) |
| ' | 357 |
| Value | Count | Frequency (%) |
| - | 318 |
| Value | Count | Frequency (%) |
| ( | 341 |
| Value | Count | Frequency (%) |
| ) | 341 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 377168 | |
| Common | 10790 | 2.8% |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 64202 | |
| i | 33422 | 8.9% |
| n | 29472 | 7.8% |
| e | 26915 | 7.1% |
| r | 20808 | 5.5% |
| o | 19334 | 5.1% |
| t | 14311 | 3.8% |
| u | 13331 | 3.5% |
| l | 13263 | 3.5% |
| d | 12818 | 3.4% |
| Other values (41) | 129292 |
| Value | Count | Frequency (%) |
| 9433 | ||
| ' | 357 | 3.3% |
| ( | 341 | 3.2% |
| ) | 341 | 3.2% |
| - | 318 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 387601 | |
| None | 357 | 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 64202 | |
| i | 33422 | 8.6% |
| n | 29472 | 7.6% |
| e | 26915 | 6.9% |
| r | 20808 | 5.4% |
| o | 19334 | 5.0% |
| t | 14311 | 3.7% |
| u | 13331 | 3.4% |
| l | 13263 | 3.4% |
| d | 12818 | 3.3% |
| Other values (45) | 139725 |
| Value | Count | Frequency (%) |
| ô | 357 |
| Distinct | 25259 |
|---|---|
| Distinct (%) | 52.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.18447907 |
| Minimum | -2153.437 |
|---|---|
| Maximum | 3475.672 |
| Zeros | 7580 |
| Zeros (%) | 15.9% |
| Negative | 46 |
| Negative (%) | 0.1% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -2153.437 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.612 |
| median | 10.206 |
| Q3 | 71.54675 |
| 95-th percentile | 349.34725 |
| Maximum | 3475.672 |
| Range | 5629.109 |
| Interquartile range (IQR) | 70.93475 |
Descriptive statistics
| Standard deviation | 160.2342026 |
|---|---|
| Coefficient of variation (CV) | 2.219787477 |
| Kurtosis | 43.43163113 |
| Mean | 72.18447907 |
| Median Absolute Deviation (MAD) | 10.206 |
| Skewness | 4.920596285 |
| Sum | 3445942.662 |
| Variance | 25674.9997 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7580 | 15.9% |
| 0.042 | 71 | 0.1% |
| 0.207 | 68 | 0.1% |
| 3.48 | 67 | 0.1% |
| 0.01 | 61 | 0.1% |
| 0.041 | 60 | 0.1% |
| 0.415 | 58 | 0.1% |
| 0.06 | 52 | 0.1% |
| 0.305 | 49 | 0.1% |
| 0.034 | 49 | 0.1% |
| Other values (25249) | 39623 |
| Value | Count | Frequency (%) |
| -2153.437 | 1 | |
| -1590.147 | 1 | |
| -705.891 | 1 | |
| -450.772 | 1 | |
| -261.576 | 1 |
| Value | Count | Frequency (%) |
| 3475.672 | 1 | |
| 3216.569 | 1 | |
| 3205.083 | 1 | |
| 3142.293 | 1 | |
| 2533.445 | 1 |
| Distinct | 7568 |
|---|---|
| Distinct (%) | 15.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2309.98674 |
| Minimum | -74347 |
|---|---|
| Maximum | 299786 |
| Zeros | 7580 |
| Zeros (%) | 15.9% |
| Negative | 46 |
| Negative (%) | 0.1% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -74347 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7 |
| median | 132 |
| Q3 | 904 |
| 95-th percentile | 9300.15 |
| Maximum | 299786 |
| Range | 374133 |
| Interquartile range (IQR) | 897 |
Descriptive statistics
| Standard deviation | 10830.40149 |
|---|---|
| Coefficient of variation (CV) | 4.688512407 |
| Kurtosis | 223.7322348 |
| Mean | 2309.98674 |
| Median Absolute Deviation (MAD) | 132 |
| Skewness | 12.85179988 |
| Sum | 110274147 |
| Variance | 117297596.5 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7580 | 15.9% |
| 1 | 1259 | 2.6% |
| 2 | 830 | 1.7% |
| 3 | 632 | 1.3% |
| 4 | 550 | 1.2% |
| 5 | 507 | 1.1% |
| 6 | 456 | 1.0% |
| 7 | 416 | 0.9% |
| 8 | 360 | 0.8% |
| 9 | 334 | 0.7% |
| Other values (7558) | 34814 |
| Value | Count | Frequency (%) |
| -74347 | 1 | |
| -46076 | 1 | |
| -17074 | 1 | |
| -10034 | 1 | |
| -7953 | 1 |
| Value | Count | Frequency (%) |
| 299786 | 1 | |
| 292105 | 1 | |
| 277068 | 1 | |
| 262337 | 1 | |
| 253993 | 1 |
| Distinct | 1268 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.26836064 |
| Minimum | -1918 |
|---|---|
| Maximum | 4465 |
| Zeros | 19595 |
| Zeros (%) | 41.0% |
| Negative | 66 |
| Negative (%) | 0.1% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -1918 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 16 |
| 95-th percentile | 242 |
| Maximum | 4465 |
| Range | 6383 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 204.7244611 |
|---|---|
| Coefficient of variation (CV) | 3.993193045 |
| Kurtosis | 121.2906125 |
| Mean | 51.26836064 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 9.156573558 |
| Sum | 2447449 |
| Variance | 41912.10497 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19595 | |
| 1 | 3730 | 7.8% |
| 2 | 2279 | 4.8% |
| 3 | 1594 | 3.3% |
| 4 | 1383 | 2.9% |
| 5 | 1143 | 2.4% |
| 6 | 910 | 1.9% |
| 7 | 741 | 1.6% |
| 8 | 728 | 1.5% |
| 9 | 602 | 1.3% |
| Other values (1258) | 15033 |
| Value | Count | Frequency (%) |
| -1918 | 1 | |
| -443 | 1 | |
| -232 | 1 | |
| -217 | 1 | |
| -117 | 1 |
| Value | Count | Frequency (%) |
| 4465 | 1 | |
| 4393 | 1 | |
| 4171 | 1 | |
| 4143 | 1 | |
| 4083 | 1 |
| Distinct | 5477 |
|---|---|
| Distinct (%) | 11.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.394059701 |
| Minimum | -67.901 |
|---|---|
| Maximum | 218.329 |
| Zeros | 19595 |
| Zeros (%) | 41.0% |
| Negative | 66 |
| Negative (%) | 0.1% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -67.901 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.106 |
| Q3 | 1.151 |
| 95-th percentile | 7.2483 |
| Maximum | 218.329 |
| Range | 286.23 |
| Interquartile range (IQR) | 1.151 |
Descriptive statistics
| Standard deviation | 3.689566427 |
|---|---|
| Coefficient of variation (CV) | 2.646634448 |
| Kurtosis | 430.1261304 |
| Mean | 1.394059701 |
| Median Absolute Deviation (MAD) | 0.106 |
| Skewness | 12.2031928 |
| Sum | 66549.622 |
| Variance | 13.61290042 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19595 | |
| 0.288 | 125 | 0.3% |
| 0.588 | 124 | 0.3% |
| 0.032 | 123 | 0.3% |
| 0.202 | 121 | 0.3% |
| 0.039 | 115 | 0.2% |
| 0.101 | 112 | 0.2% |
| 0.347 | 111 | 0.2% |
| 0.093 | 108 | 0.2% |
| 0.034 | 100 | 0.2% |
| Other values (5467) | 27104 |
| Value | Count | Frequency (%) |
| -67.901 | 1 | |
| -41.023 | 1 | |
| -22.972 | 1 | |
| -12.248 | 1 | |
| -10.095 | 1 |
| Value | Count | Frequency (%) |
| 218.329 | 1 | |
| 141.865 | 1 | |
| 125.653 | 1 | |
| 117.888 | 1 | |
| 111.431 | 1 |
latitude
Real number (ℝ)
| Distinct | 131 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.02888733 |
| Minimum | -40.900557 |
|---|---|
| Maximum | 61.92411 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 9011 |
| Negative (%) | 18.9% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -40.900557 |
|---|---|
| 5-th percentile | -23.442503 |
| Q1 | 7.873054 |
| median | 23.634501 |
| Q3 | 43.915886 |
| 95-th percentile | 56.26392 |
| Maximum | 61.92411 |
| Range | 102.824667 |
| Interquartile range (IQR) | 36.042832 |
Descriptive statistics
| Standard deviation | 24.95775874 |
|---|---|
| Coefficient of variation (CV) | 1.13295594 |
| Kurtosis | -0.4655304742 |
| Mean | 22.02888733 |
| Median Absolute Deviation (MAD) | 17.974134 |
| Skewness | -0.4875528992 |
| Sum | 1051615.023 |
| Variance | 622.8897213 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.352083 | 382 | 0.8% |
| 28.394857 | 382 | 0.8% |
| 12.565679 | 382 | 0.8% |
| 36.204824 | 382 | 0.8% |
| 12.879721 | 382 | 0.8% |
| -25.274398 | 382 | 0.8% |
| 60.128161 | 382 | 0.8% |
| 56.130366 | 382 | 0.8% |
| 15.870032 | 382 | 0.8% |
| 41.87194 | 382 | 0.8% |
| Other values (121) | 43918 |
| Value | Count | Frequency (%) |
| -40.900557 | 369 | |
| -38.416097 | 382 | |
| -35.675147 | 374 | |
| -32.522779 | 355 | |
| -30.559482 | 382 |
| Value | Count | Frequency (%) |
| 61.92411 | 382 | |
| 61.52401 | 382 | |
| 60.472024 | 374 | |
| 60.128161 | 382 | |
| 58.595272 | 371 |
longitude
Real number (ℝ)
| Distinct | 131 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.03663629 |
| Minimum | -106.346771 |
|---|---|
| Maximum | 178.065032 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 14097 |
| Negative (%) | 29.5% |
| Memory size | 373.1 KiB |
Quantile statistics
| Minimum | -106.346771 |
|---|---|
| 5-th percentile | -86.241905 |
| Q1 | -5.54708 |
| median | 19.145136 |
| Q3 | 48.516388 |
| 95-th percentile | 121.774017 |
| Maximum | 178.065032 |
| Range | 284.411803 |
| Interquartile range (IQR) | 54.063468 |
Descriptive statistics
| Standard deviation | 62.01120499 |
|---|---|
| Coefficient of variation (CV) | 3.438069272 |
| Kurtosis | -0.1984005117 |
| Mean | 18.03663629 |
| Median Absolute Deviation (MAD) | 27.36959 |
| Skewness | 0.06277719199 |
| Sum | 861032.9431 |
| Variance | 3845.389544 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| -3.435973 | 382 | 0.8% |
| 25.748151 | 382 | 0.8% |
| 18.643501 | 382 | 0.8% |
| 103.819836 | 382 | 0.8% |
| 133.775136 | 382 | 0.8% |
| 78.96288 | 382 | 0.8% |
| 14.375416 | 382 | 0.8% |
| 80.771797 | 382 | 0.8% |
| 104.990963 | 382 | 0.8% |
| 127.766922 | 382 | 0.8% |
| Other values (121) | 43918 |
| Value | Count | Frequency (%) |
| -106.346771 | 382 | |
| -102.552784 | 382 | |
| -95.712891 | 382 | |
| -90.230759 | 380 | |
| -88.89653 | 349 |
| Value | Count | Frequency (%) |
| 178.065032 | 382 | |
| 174.885971 | 369 | |
| 143.95555 | 345 | |
| 138.252924 | 382 | |
| 133.775136 | 382 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| iso_code | date | retail_and_recreation_percent_change_from_baseline | grocery_and_pharmacy_percent_change_from_baseline | parks_percent_change_from_baseline | transit_stations_percent_change_from_baseline | workplaces_percent_change_from_baseline | residential_percent_change_from_baseline | country_region | new_cases_per_million | new_cases | new_deaths | new_deaths_per_million | latitude | longitude | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | ARE | 2020-02-15 | 0.0 | 4.0 | 5.0 | 0.0 | 2.0 | 1.0 | United Arab Emirates | 0.000 | 0.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 1 | ARE | 2020-02-16 | 1.0 | 4.0 | 4.0 | 1.0 | 2.0 | 1.0 | United Arab Emirates | 0.101 | 1.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 2 | ARE | 2020-02-17 | -1.0 | 1.0 | 5.0 | 1.0 | 2.0 | 1.0 | United Arab Emirates | 0.000 | 0.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 3 | ARE | 2020-02-18 | -2.0 | 1.0 | 5.0 | 0.0 | 2.0 | 1.0 | United Arab Emirates | 0.000 | 0.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 4 | ARE | 2020-02-19 | -2.0 | 0.0 | 4.0 | -1.0 | 2.0 | 1.0 | United Arab Emirates | 0.000 | 0.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 5 | ARE | 2020-02-20 | -2.0 | 1.0 | 6.0 | 1.0 | 1.0 | 1.0 | United Arab Emirates | 0.000 | 0.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 6 | ARE | 2020-02-21 | -3.0 | 2.0 | 6.0 | 0.0 | -1.0 | 1.0 | United Arab Emirates | 0.000 | 0.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 7 | ARE | 2020-02-22 | -2.0 | 2.0 | 4.0 | -2.0 | 3.0 | 1.0 | United Arab Emirates | 0.404 | 4.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 8 | ARE | 2020-02-23 | -1.0 | 3.0 | 3.0 | -1.0 | 4.0 | 1.0 | United Arab Emirates | 0.000 | 0.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
| 9 | ARE | 2020-02-24 | -3.0 | 0.0 | 5.0 | -1.0 | 3.0 | 1.0 | United Arab Emirates | 0.000 | 0.0 | 0.0 | 0.0 | 23.424076 | 53.847818 |
Last rows
| iso_code | date | retail_and_recreation_percent_change_from_baseline | grocery_and_pharmacy_percent_change_from_baseline | parks_percent_change_from_baseline | transit_stations_percent_change_from_baseline | workplaces_percent_change_from_baseline | residential_percent_change_from_baseline | country_region | new_cases_per_million | new_cases | new_deaths | new_deaths_per_million | latitude | longitude | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47728 | ZWE | 2021-02-21 | -20.0 | 6.0 | 2.0 | -33.0 | -13.0 | 9.0 | Zimbabwe | 1.884 | 28.0 | 4.0 | 0.269 | -19.015438 | 29.154857 |
| 47729 | ZWE | 2021-02-22 | -36.0 | -15.0 | -17.0 | -43.0 | -66.0 | 21.0 | Zimbabwe | 4.441 | 66.0 | 5.0 | 0.336 | -19.015438 | 29.154857 |
| 47730 | ZWE | 2021-02-23 | -17.0 | 4.0 | -12.0 | -26.0 | -20.0 | 10.0 | Zimbabwe | 3.230 | 48.0 | 7.0 | 0.471 | -19.015438 | 29.154857 |
| 47731 | ZWE | 2021-02-24 | -17.0 | 8.0 | -11.0 | -25.0 | -21.0 | 12.0 | Zimbabwe | 3.364 | 50.0 | 8.0 | 0.538 | -19.015438 | 29.154857 |
| 47732 | ZWE | 2021-02-25 | -13.0 | 9.0 | -12.0 | -22.0 | -21.0 | 12.0 | Zimbabwe | 2.288 | 34.0 | 2.0 | 0.135 | -19.015438 | 29.154857 |
| 47733 | ZWE | 2021-02-26 | -18.0 | 8.0 | -17.0 | -27.0 | -18.0 | 12.0 | Zimbabwe | 3.364 | 50.0 | 5.0 | 0.336 | -19.015438 | 29.154857 |
| 47734 | ZWE | 2021-02-27 | -13.0 | 19.0 | -9.0 | -24.0 | -7.0 | 5.0 | Zimbabwe | 0.942 | 14.0 | 0.0 | 0.000 | -19.015438 | 29.154857 |
| 47735 | ZWE | 2021-02-28 | -21.0 | 8.0 | -15.0 | -29.0 | -10.0 | 8.0 | Zimbabwe | 2.086 | 31.0 | 0.0 | 0.000 | -19.015438 | 29.154857 |
| 47736 | ZWE | 2021-03-01 | -12.0 | 7.0 | -12.0 | -21.0 | -18.0 | 10.0 | Zimbabwe | 1.749 | 26.0 | 5.0 | 0.336 | -19.015438 | 29.154857 |
| 47737 | ZWE | 2021-03-02 | -2.0 | 26.0 | 1.0 | -11.0 | -14.0 | 8.0 | Zimbabwe | 2.220 | 33.0 | 4.0 | 0.269 | -19.015438 | 29.154857 |